/*
 Navicat Premium Data Transfer

 Source Server         : 群众H5
 Source Server Type    : MySQL
 Source Server Version : 50740 (5.7.40-log)
 Source Host           : 119.23.152.10:3306
 Source Schema         : masses_xyzac_cn

 Target Server Type    : MySQL
 Target Server Version : 50740 (5.7.40-log)
 File Encoding         : 65001

 Date: 31/07/2025 17:13:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Ma_activity
-- ----------------------------
DROP TABLE IF EXISTS `Ma_activity`;
CREATE TABLE `Ma_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '活动标题',
  `cover` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '活动封面',
  `introduce` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '活动介绍',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '活动内容',
  `weigh` int(11) DEFAULT NULL COMMENT '排序',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of Ma_activity
-- ----------------------------
BEGIN;
INSERT INTO `Ma_activity` (`id`, `title`, `cover`, `introduce`, `content`, `weigh`, `status`, `create_time`, `update_time`) VALUES (1, '克拉玛依市独山子区卫生健康委员会', '/storage/default/20250514/1723787910471068e2400bfb17590b96bcd7af7587eae8436ad0d.png', '有氧有健', '<ul><li>111正文1</li></ul>', 1, 1, 1747235810, 1751021600);
COMMIT;

-- ----------------------------
-- Table structure for Ma_admin
-- ----------------------------
DROP TABLE IF EXISTS `Ma_admin`;
CREATE TABLE `Ma_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '头像',
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '邮箱',
  `mobile` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '手机',
  `login_failure` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '登录失败次数',
  `last_login_time` bigint(16) unsigned DEFAULT NULL COMMENT '上次登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '上次登录IP',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码盐（废弃待删）',
  `motto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '签名',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '状态:enable=启用,disable=禁用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员表';

-- ----------------------------
-- Records of Ma_admin
-- ----------------------------
BEGIN;
INSERT INTO `Ma_admin` (`id`, `username`, `nickname`, `avatar`, `email`, `mobile`, `login_failure`, `last_login_time`, `last_login_ip`, `password`, `salt`, `motto`, `status`, `update_time`, `create_time`) VALUES (1, 'admin', 'Admin', '', 'admin@buildadmin.com', '18888888888', 0, 1753950517, '112.43.208.182', '$2y$10$uogkHbXKPifeukcV8Fyh0.LACw9c6QBSvglQ.kSApj5RHPX6wIsN.', '', '', 'enable', 1753950517, 1747216796);
COMMIT;

-- ----------------------------
-- Table structure for Ma_admin_group
-- ----------------------------
DROP TABLE IF EXISTS `Ma_admin_group`;
CREATE TABLE `Ma_admin_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级分组',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组名',
  `rules` text COLLATE utf8mb4_unicode_ci COMMENT '权限规则ID',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理分组表';

-- ----------------------------
-- Records of Ma_admin_group
-- ----------------------------
BEGIN;
INSERT INTO `Ma_admin_group` (`id`, `pid`, `name`, `rules`, `status`, `update_time`, `create_time`) VALUES (1, 0, '超级管理组', '*', 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_group` (`id`, `pid`, `name`, `rules`, `status`, `update_time`, `create_time`) VALUES (2, 1, '一级管理员', '1,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,77,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,89', 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_group` (`id`, `pid`, `name`, `rules`, `status`, `update_time`, `create_time`) VALUES (3, 2, '二级管理员', '21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43', 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_group` (`id`, `pid`, `name`, `rules`, `status`, `update_time`, `create_time`) VALUES (4, 3, '三级管理员', '55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75', 1, 1747216796, 1747216796);
COMMIT;

-- ----------------------------
-- Table structure for Ma_admin_group_access
-- ----------------------------
DROP TABLE IF EXISTS `Ma_admin_group_access`;
CREATE TABLE `Ma_admin_group_access` (
  `uid` int(11) unsigned NOT NULL COMMENT '管理员ID',
  `group_id` int(11) unsigned NOT NULL COMMENT '分组ID',
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理分组映射表';

-- ----------------------------
-- Records of Ma_admin_group_access
-- ----------------------------
BEGIN;
INSERT INTO `Ma_admin_group_access` (`uid`, `group_id`) VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for Ma_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `Ma_admin_log`;
CREATE TABLE `Ma_admin_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '管理员用户名',
  `url` varchar(1500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作Url',
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '日志标题',
  `data` longtext COLLATE utf8mb4_unicode_ci COMMENT '请求数据',
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员日志表';

-- ----------------------------
-- Records of Ma_admin_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_admin_rule
-- ----------------------------
DROP TABLE IF EXISTS `Ma_admin_rule`;
CREATE TABLE `Ma_admin_rule` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单',
  `type` enum('menu_dir','menu','button') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'menu' COMMENT '类型:menu_dir=菜单目录,menu=菜单项,button=页面按钮',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则名称',
  `path` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '路由路径',
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图标',
  `menu_type` enum('tab','link','iframe') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单类型:tab=选项卡,link=链接,iframe=Iframe',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Url',
  `component` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组件路径',
  `keepalive` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '缓存:0=关闭,1=开启',
  `extend` enum('none','add_rules_only','add_menu_only') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none' COMMENT '扩展属性:none=无,add_rules_only=只添加为路由,add_menu_only=只添加为菜单',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `weigh` int(11) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='菜单和权限规则表';

-- ----------------------------
-- Records of Ma_admin_rule
-- ----------------------------
BEGIN;
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (1, 0, 'menu', '控制台', 'dashboard', 'dashboard', 'fa fa-dashboard', 'tab', '', '/src/views/backend/dashboard.vue', 1, 'none', 'Remark lang', 999, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (2, 0, 'menu_dir', '权限管理', 'auth', 'auth', 'fa fa-group', NULL, '', '', 0, 'none', '', 100, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (3, 2, 'menu', '角色组管理', 'auth/group', 'auth/group', 'fa fa-group', 'tab', '', '/src/views/backend/auth/group/index.vue', 1, 'none', 'Remark lang', 99, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (4, 3, 'button', '查看', 'auth/group/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (5, 3, 'button', '添加', 'auth/group/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (6, 3, 'button', '编辑', 'auth/group/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (7, 3, 'button', '删除', 'auth/group/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (8, 2, 'menu', '管理员管理', 'auth/admin', 'auth/admin', 'el-icon-UserFilled', 'tab', '', '/src/views/backend/auth/admin/index.vue', 1, 'none', '', 98, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (9, 8, 'button', '查看', 'auth/admin/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (10, 8, 'button', '添加', 'auth/admin/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (11, 8, 'button', '编辑', 'auth/admin/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (12, 8, 'button', '删除', 'auth/admin/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (13, 2, 'menu', '菜单规则管理', 'auth/rule', 'auth/rule', 'el-icon-Grid', 'tab', '', '/src/views/backend/auth/rule/index.vue', 1, 'none', '', 97, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (14, 13, 'button', '查看', 'auth/rule/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (15, 13, 'button', '添加', 'auth/rule/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (16, 13, 'button', '编辑', 'auth/rule/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (17, 13, 'button', '删除', 'auth/rule/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (18, 13, 'button', '快速排序', 'auth/rule/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (19, 2, 'menu', '管理员日志管理', 'auth/adminLog', 'auth/adminLog', 'el-icon-List', 'tab', '', '/src/views/backend/auth/adminLog/index.vue', 1, 'none', '', 96, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (20, 19, 'button', '查看', 'auth/adminLog/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (21, 0, 'menu_dir', '会员管理', 'user', 'user', 'fa fa-drivers-license', NULL, '', '', 0, 'none', '', 95, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (22, 21, 'menu', '会员管理', 'user/user', 'user/user', 'fa fa-user', 'tab', '', '/src/views/backend/user/user/index.vue', 1, 'none', '', 94, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (23, 22, 'button', '查看', 'user/user/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (24, 22, 'button', '添加', 'user/user/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (25, 22, 'button', '编辑', 'user/user/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (26, 22, 'button', '删除', 'user/user/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (44, 0, 'menu_dir', '常规管理', 'routine', 'routine', 'fa fa-cogs', NULL, '', '', 0, 'none', '', 89, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (45, 44, 'menu', '系统配置', 'routine/config', 'routine/config', 'el-icon-Tools', 'tab', '', '/src/views/backend/routine/config/index.vue', 1, 'none', '', 88, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (46, 45, 'button', '查看', 'routine/config/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (47, 45, 'button', '编辑', 'routine/config/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (48, 44, 'menu', '附件管理', 'routine/attachment', 'routine/attachment', 'fa fa-folder', 'tab', '', '/src/views/backend/routine/attachment/index.vue', 1, 'none', 'Remark lang', 87, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (49, 48, 'button', '查看', 'routine/attachment/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (50, 48, 'button', '编辑', 'routine/attachment/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (51, 48, 'button', '删除', 'routine/attachment/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (52, 44, 'menu', '个人资料', 'routine/adminInfo', 'routine/adminInfo', 'fa fa-user', 'tab', '', '/src/views/backend/routine/adminInfo.vue', 1, 'none', '', 86, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (53, 52, 'button', '查看', 'routine/adminInfo/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (54, 52, 'button', '编辑', 'routine/adminInfo/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (55, 0, 'menu_dir', '数据安全管理', 'security', 'security', 'fa fa-shield', NULL, '', '', 0, 'none', '', 85, 0, 1748499797, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (56, 55, 'menu', '数据回收站', 'security/dataRecycleLog', 'security/dataRecycleLog', 'fa fa-database', 'tab', '', '/src/views/backend/security/dataRecycleLog/index.vue', 1, 'none', '', 84, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (57, 56, 'button', '查看', 'security/dataRecycleLog/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (58, 56, 'button', '删除', 'security/dataRecycleLog/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (59, 56, 'button', '还原', 'security/dataRecycleLog/restore', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (60, 56, 'button', '查看详情', 'security/dataRecycleLog/info', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (61, 55, 'menu', '敏感数据修改记录', 'security/sensitiveDataLog', 'security/sensitiveDataLog', 'fa fa-expeditedssl', 'tab', '', '/src/views/backend/security/sensitiveDataLog/index.vue', 1, 'none', '', 83, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (62, 61, 'button', '查看', 'security/sensitiveDataLog/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (63, 61, 'button', '删除', 'security/sensitiveDataLog/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (64, 61, 'button', '回滚', 'security/sensitiveDataLog/rollback', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (65, 61, 'button', '查看详情', 'security/sensitiveDataLog/info', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (66, 55, 'menu', '数据回收规则管理', 'security/dataRecycle', 'security/dataRecycle', 'fa fa-database', 'tab', '', '/src/views/backend/security/dataRecycle/index.vue', 1, 'none', 'Remark lang', 82, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (67, 66, 'button', '查看', 'security/dataRecycle/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (68, 66, 'button', '添加', 'security/dataRecycle/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (69, 66, 'button', '编辑', 'security/dataRecycle/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (70, 66, 'button', '删除', 'security/dataRecycle/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (71, 55, 'menu', '敏感字段规则管理', 'security/sensitiveData', 'security/sensitiveData', 'fa fa-expeditedssl', 'tab', '', '/src/views/backend/security/sensitiveData/index.vue', 1, 'none', 'Remark lang', 81, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (72, 71, 'button', '查看', 'security/sensitiveData/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (73, 71, 'button', '添加', 'security/sensitiveData/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (74, 71, 'button', '编辑', 'security/sensitiveData/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (75, 71, 'button', '删除', 'security/sensitiveData/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (77, 45, 'button', '添加', 'routine/config/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (88, 45, 'button', '删除', 'routine/config/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216796, 1747216796);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (89, 1, 'button', '查看', 'dashboard/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747216799, 1747216799);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (90, 0, 'menu', '轮播图', 'banner', 'banner', '', 'tab', '', '/src/views/backend/banner/index.vue', 1, 'none', '', 0, 1, 1747232072, 1747232072);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (91, 90, 'button', '查看', 'banner/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747232072, 1747232072);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (92, 90, 'button', '添加', 'banner/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747232072, 1747232072);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (93, 90, 'button', '编辑', 'banner/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747232072, 1747232072);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (94, 90, 'button', '删除', 'banner/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747232072, 1747232072);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (95, 90, 'button', '快速排序', 'banner/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747232072, 1747232072);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (96, 0, 'menu', '活动通知', 'activity', 'activity', '', 'tab', '', '/src/views/backend/activity/index.vue', 1, 'none', '', 0, 1, 1747235311, 1747235311);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (97, 96, 'button', '查看', 'activity/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235311, 1747235311);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (98, 96, 'button', '添加', 'activity/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235311, 1747235311);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (99, 96, 'button', '编辑', 'activity/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235311, 1747235311);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (100, 96, 'button', '删除', 'activity/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235311, 1747235311);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (101, 96, 'button', '快速排序', 'activity/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235311, 1747235311);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (102, 0, 'menu', '评论管理', 'comment', 'comment', '', 'tab', '', '/src/views/backend/comment/index.vue', 1, 'none', '', 0, 1, 1747235335, 1747235335);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (103, 102, 'button', '查看', 'comment/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235335, 1747235335);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (104, 102, 'button', '添加', 'comment/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235335, 1747235335);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (105, 102, 'button', '编辑', 'comment/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235335, 1747235335);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (106, 102, 'button', '删除', 'comment/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235335, 1747235335);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (107, 102, 'button', '快速排序', 'comment/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235335, 1747235335);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (108, 0, 'menu_dir', '课程管理', 'course', 'course', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235366, 1747235366);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (109, 108, 'menu', '课程类别', 'course/cate', 'course/cate', '', 'tab', '', '/src/views/backend/course/cate/index.vue', 1, 'none', '', 0, 1, 1747235366, 1747235366);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (110, 109, 'button', '查看', 'course/cate/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235366, 1747235366);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (111, 109, 'button', '添加', 'course/cate/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235366, 1747235366);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (112, 109, 'button', '编辑', 'course/cate/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235366, 1747235366);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (113, 109, 'button', '删除', 'course/cate/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235366, 1747235366);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (114, 109, 'button', '快速排序', 'course/cate/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235366, 1747235366);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (115, 0, 'menu', '调查问券', 'questionCoupon', 'questionCoupon', '', 'tab', '', '/src/views/backend/questionCoupon/index.vue', 1, 'none', '', 0, 1, 1747235406, 1747235406);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (116, 115, 'button', '查看', 'questionCoupon/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235406, 1747235406);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (117, 115, 'button', '添加', 'questionCoupon/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235406, 1747235406);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (118, 115, 'button', '编辑', 'questionCoupon/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235406, 1747235406);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (119, 115, 'button', '删除', 'questionCoupon/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235406, 1747235406);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (120, 115, 'button', '快速排序', 'questionCoupon/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747235406, 1747235406);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (121, 0, 'menu', '平台消息', 'noticeLog', 'noticeLog', '', 'tab', '', '/src/views/backend/noticeLog/index.vue', 1, 'none', '', 0, 1, 1747239568, 1747239568);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (122, 121, 'button', '查看', 'noticeLog/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747239569, 1747239569);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (123, 121, 'button', '添加', 'noticeLog/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747239569, 1747239569);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (124, 121, 'button', '编辑', 'noticeLog/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747239569, 1747239569);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (125, 121, 'button', '删除', 'noticeLog/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747239569, 1747239569);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (126, 121, 'button', '快速排序', 'noticeLog/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747239569, 1747239569);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (127, 108, 'menu', '课程类目', 'course/catelog', 'course/catelog', '', 'tab', '', '/src/views/backend/course/catelog/index.vue', 1, 'none', '', 0, 1, 1747314519, 1747314519);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (128, 127, 'button', '查看', 'course/catelog/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314519, 1747314519);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (129, 127, 'button', '添加', 'course/catelog/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314519, 1747314519);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (130, 127, 'button', '编辑', 'course/catelog/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314519, 1747314519);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (131, 127, 'button', '删除', 'course/catelog/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314519, 1747314519);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (132, 127, 'button', '快速排序', 'course/catelog/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314519, 1747314519);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (133, 108, 'menu', '课程', 'course/course', 'course/course', '', 'tab', '', '/src/views/backend/course/course/index.vue', 1, 'none', '', 0, 1, 1747314640, 1747314640);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (134, 133, 'button', '查看', 'course/course/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314640, 1747314640);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (135, 133, 'button', '添加', 'course/course/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314640, 1747314640);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (136, 133, 'button', '编辑', 'course/course/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314640, 1747314640);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (137, 133, 'button', '删除', 'course/course/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314640, 1747314640);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (138, 133, 'button', '快速排序', 'course/course/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747314640, 1747314640);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (139, 108, 'menu', '用户评论管理', 'course/userComment', 'course/userComment', '', 'tab', '', '/src/views/backend/course/userComment/index.vue', 1, 'none', '', 0, 1, 1747324896, 1747324896);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (140, 139, 'button', '查看', 'course/userComment/index', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747324896, 1747324896);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (141, 139, 'button', '添加', 'course/userComment/add', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747324896, 1747324896);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (142, 139, 'button', '编辑', 'course/userComment/edit', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747324896, 1747324896);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (143, 139, 'button', '删除', 'course/userComment/del', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747324896, 1747324896);
INSERT INTO `Ma_admin_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `keepalive`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (144, 139, 'button', '快速排序', 'course/userComment/sortable', '', '', NULL, '', '', 0, 'none', '', 0, 1, 1747324896, 1747324896);
COMMIT;

-- ----------------------------
-- Table structure for Ma_area
-- ----------------------------
DROP TABLE IF EXISTS `Ma_area`;
CREATE TABLE `Ma_area` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(11) unsigned DEFAULT NULL COMMENT '父id',
  `shortname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简称',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `mergename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '全称',
  `level` tinyint(4) unsigned DEFAULT NULL COMMENT '层级:1=省,2=市,3=区/县',
  `pinyin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拼音',
  `code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '长途区号',
  `zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮编',
  `first` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '首字母',
  `lng` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '经度',
  `lat` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='省份地区表';

-- ----------------------------
-- Records of Ma_area
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_attachment
-- ----------------------------
DROP TABLE IF EXISTS `Ma_attachment`;
CREATE TABLE `Ma_attachment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `topic` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '细目',
  `admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上传管理员ID',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上传用户ID',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '物理路径',
  `width` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '宽度',
  `height` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '高度',
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '原始名称',
  `size` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '大小',
  `mimetype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'mime类型',
  `quote` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上传(引用)次数',
  `storage` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '存储方式',
  `sha1` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'sha1编码',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  `last_upload_time` bigint(16) unsigned DEFAULT NULL COMMENT '最后上传时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='附件表';

-- ----------------------------
-- Records of Ma_attachment
-- ----------------------------
BEGIN;
INSERT INTO `Ma_attachment` (`id`, `topic`, `admin_id`, `user_id`, `url`, `width`, `height`, `name`, `size`, `mimetype`, `quote`, `storage`, `sha1`, `create_time`, `last_upload_time`) VALUES (1, 'default', 1, 0, '/storage/default/20250514/1723787910471068e2400bfb17590b96bcd7af7587eae8436ad0d.png', 1024, 1024, '1723787910471.png', 1286894, 'image/png', 6, 'local', '068e2400bfb17590b96bcd7af7587eae8436ad0d', 1747235661, 1748508230);
INSERT INTO `Ma_attachment` (`id`, `topic`, `admin_id`, `user_id`, `url`, `width`, `height`, `name`, `size`, `mimetype`, `quote`, `storage`, `sha1`, `create_time`, `last_upload_time`) VALUES (2, 'default', 1, 0, '/storage/default/20250515/111390ba142c8c7ae0d7b52f0868f1d4e5f2e6adb4a.mp4', 0, 0, '111.mp4', 2344728, 'video/mp4', 1, 'local', '390ba142c8c7ae0d7b52f0868f1d4e5f2e6adb4a', 1747315870, 1747315870);
INSERT INTO `Ma_attachment` (`id`, `topic`, `admin_id`, `user_id`, `url`, `width`, `height`, `name`, `size`, `mimetype`, `quote`, `storage`, `sha1`, `create_time`, `last_upload_time`) VALUES (3, 'default', 1, 0, '/storage/default/20250515/36091164c45e5b0cabb8c7e46eb458f75557bc070aa814f4e440527.mp4', 0, 0, '36091164c45e5b0f5029a05ec39a1771-2025-03-2111_18_55.mp4', 5410400, 'video/mp4', 2, 'local', 'cabb8c7e46eb458f75557bc070aa814f4e440527', 1747316300, 1748507340);
INSERT INTO `Ma_attachment` (`id`, `topic`, `admin_id`, `user_id`, `url`, `width`, `height`, `name`, `size`, `mimetype`, `quote`, `storage`, `sha1`, `create_time`, `last_upload_time`) VALUES (4, 'default', 1, 0, '/storage/default/20250529/哪吒d40e520afab495da90b9fe5e4c92abbca16ba7ed.mp4', 0, 0, '哪吒.mp4', 2342243, 'video/mp4', 1, 'local', 'd40e520afab495da90b9fe5e4c92abbca16ba7ed', 1748508247, 1748508247);
INSERT INTO `Ma_attachment` (`id`, `topic`, `admin_id`, `user_id`, `url`, `width`, `height`, `name`, `size`, `mimetype`, `quote`, `storage`, `sha1`, `create_time`, `last_upload_time`) VALUES (5, 'default', 1, 0, '/storage/default/20250627/10ca147cfe83aeebc0df2b10dbf36f44e6dfb264f.jpg', 1280, 1280, '1.jpg', 126826, 'image/jpeg', 1, 'local', '0ca147cfe83aeebc0df2b10dbf36f44e6dfb264f', 1751016628, 1751016628);
COMMIT;

-- ----------------------------
-- Table structure for Ma_banner
-- ----------------------------
DROP TABLE IF EXISTS `Ma_banner`;
CREATE TABLE `Ma_banner` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cover` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `href` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '跳转地址',
  `weigh` int(10) unsigned DEFAULT '0' COMMENT '排序',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='轮播图';

-- ----------------------------
-- Records of Ma_banner
-- ----------------------------
BEGIN;
INSERT INTO `Ma_banner` (`id`, `cover`, `status`, `href`, `weigh`, `create_time`, `update_time`) VALUES (1, '/storage/default/20250627/10ca147cfe83aeebc0df2b10dbf36f44e6dfb264f.jpg', 1, '', 1, 0, 1751016632);
COMMIT;

-- ----------------------------
-- Table structure for Ma_captcha
-- ----------------------------
DROP TABLE IF EXISTS `Ma_captcha`;
CREATE TABLE `Ma_captcha` (
  `key` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '验证码Key',
  `code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '验证码(加密后)',
  `captcha` text COLLATE utf8mb4_unicode_ci COMMENT '验证码数据',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  `expire_time` bigint(16) unsigned DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='验证码表';

-- ----------------------------
-- Records of Ma_captcha
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_catelog
-- ----------------------------
DROP TABLE IF EXISTS `Ma_catelog`;
CREATE TABLE `Ma_catelog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ' ',
  `title` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='课程类目';

-- ----------------------------
-- Records of Ma_catelog
-- ----------------------------
BEGIN;
INSERT INTO `Ma_catelog` (`id`, `title`, `status`, `create_time`, `update_time`) VALUES (1, '目录1', 1, 1747314973, 1747314973);
COMMIT;

-- ----------------------------
-- Table structure for Ma_comment
-- ----------------------------
DROP TABLE IF EXISTS `Ma_comment`;
CREATE TABLE `Ma_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ' ',
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '评论',
  `weigh` int(10) DEFAULT NULL COMMENT '排序',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='评论管理';

-- ----------------------------
-- Records of Ma_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_config
-- ----------------------------
DROP TABLE IF EXISTS `Ma_config`;
CREATE TABLE `Ma_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '变量名',
  `group` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分组',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '变量标题',
  `tip` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '变量描述',
  `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '变量输入组件类型',
  `value` longtext COLLATE utf8mb4_unicode_ci COMMENT '变量值',
  `content` longtext COLLATE utf8mb4_unicode_ci COMMENT '字典数据',
  `rule` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '验证规则',
  `extend` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '扩展属性',
  `allow_del` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '允许删除:0=否,1=是',
  `weigh` int(11) NOT NULL DEFAULT '0' COMMENT '权重',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统配置';

-- ----------------------------
-- Records of Ma_config
-- ----------------------------
BEGIN;
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (1, 'config_group', 'basics', 'Config group', '', 'array', '[{\"key\":\"basics\",\"value\":\"Basics\"},{\"key\":\"mail\",\"value\":\"Mail\"},{\"key\":\"config_quick_entrance\",\"value\":\"Config Quick entrance\"}]', NULL, 'required', '', 0, -1);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (2, 'site_name', 'basics', 'Site Name', '', 'string', 'MassesAdmin', NULL, 'required', '', 0, 99);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (3, 'record_number', 'basics', 'Record number', '域名备案号', 'string', '渝ICP备8888888号-1', NULL, '', '', 0, 0);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (4, 'version', 'basics', 'Version number', '系统版本号', 'string', 'v1.0.0', NULL, 'required', '', 0, 0);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (5, 'time_zone', 'basics', 'time zone', '', 'string', 'Asia/Shanghai', NULL, 'required', '', 0, 0);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (6, 'no_access_ip', 'basics', 'No access ip', '禁止访问站点的ip列表,一行一个', 'textarea', NULL, NULL, '', '', 0, 0);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (7, 'smtp_server', 'mail', 'smtp server', '', 'string', 'smtp.qq.com', NULL, '', '', 0, 9);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (8, 'smtp_port', 'mail', 'smtp port', '', 'string', '465', NULL, '', '', 0, 8);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (9, 'smtp_user', 'mail', 'smtp user', '', 'string', NULL, NULL, '', '', 0, 7);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (10, 'smtp_pass', 'mail', 'smtp pass', '', 'string', NULL, NULL, '', '', 0, 6);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (11, 'smtp_verification', 'mail', 'smtp verification', '', 'select', 'SSL', '{\"SSL\":\"SSL\",\"TLS\":\"TLS\"}', '', '', 0, 5);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (12, 'smtp_sender_mail', 'mail', 'smtp sender mail', '', 'string', NULL, NULL, 'email', '', 0, 4);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (13, 'config_quick_entrance', 'config_quick_entrance', 'Config Quick entrance', '', 'array', '[{\"key\":\"\\u6570\\u636e\\u56de\\u6536\\u89c4\\u5219\\u914d\\u7f6e\",\"value\":\"security\\/dataRecycle\"},{\"key\":\"\\u654f\\u611f\\u6570\\u636e\\u89c4\\u5219\\u914d\\u7f6e\",\"value\":\"security\\/sensitiveData\"}]', NULL, '', '', 0, 0);
INSERT INTO `Ma_config` (`id`, `name`, `group`, `title`, `tip`, `type`, `value`, `content`, `rule`, `extend`, `allow_del`, `weigh`) VALUES (14, 'backend_entrance', 'basics', 'Backend entrance', '', 'string', '/admin', NULL, 'required', '', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for Ma_course
-- ----------------------------
DROP TABLE IF EXISTS `Ma_course`;
CREATE TABLE `Ma_course` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ' ',
  `course_cate_id` int(11) DEFAULT NULL COMMENT '课程分类',
  `catelog_id` int(11) DEFAULT NULL COMMENT '类目ID',
  `cover` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面',
  `duration` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '时长',
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '课程标题',
  `watch` int(11) DEFAULT NULL COMMENT '观看人数',
  `video` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '视频链接',
  `recommend` tinyint(1) DEFAULT NULL COMMENT '推荐',
  `weigh` int(11) DEFAULT NULL COMMENT '排序',
  `introduce` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '介绍',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '详情',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='课程';

-- ----------------------------
-- Records of Ma_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_course_cate
-- ----------------------------
DROP TABLE IF EXISTS `Ma_course_cate`;
CREATE TABLE `Ma_course_cate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类标题',
  `weigh` int(11) DEFAULT NULL COMMENT '排序',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='课程类别';

-- ----------------------------
-- Records of Ma_course_cate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_course_comment
-- ----------------------------
DROP TABLE IF EXISTS `Ma_course_comment`;
CREATE TABLE `Ma_course_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` int(10) unsigned DEFAULT '0' COMMENT '评论ID',
  `course_id` int(11) DEFAULT NULL COMMENT '课程ID',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of Ma_course_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_course_user_comment
-- ----------------------------
DROP TABLE IF EXISTS `Ma_course_user_comment`;
CREATE TABLE `Ma_course_user_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(10) unsigned DEFAULT NULL COMMENT '课程ID',
  `comment_id` int(11) DEFAULT NULL COMMENT '评论ID',
  `comment` varchar(300) DEFAULT NULL COMMENT '评论内容',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `avatar` varchar(500) DEFAULT NULL COMMENT '头像',
  `nickname` varchar(300) DEFAULT NULL COMMENT '昵称',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of Ma_course_user_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_crud_log
-- ----------------------------
DROP TABLE IF EXISTS `Ma_crud_log`;
CREATE TABLE `Ma_crud_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `table_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据表名',
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '注释',
  `table` text COLLATE utf8mb4_unicode_ci COMMENT '数据表数据',
  `fields` text COLLATE utf8mb4_unicode_ci COMMENT '字段数据',
  `sync` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '同步记录',
  `status` enum('delete','success','error','start') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'start' COMMENT '状态:delete=已删除,success=成功,error=失败,start=生成中',
  `connection` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据库连接配置标识',
  `create_time` bigint(20) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='CRUD记录表';

-- ----------------------------
-- Records of Ma_crud_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_migrations
-- ----------------------------
DROP TABLE IF EXISTS `Ma_migrations`;
CREATE TABLE `Ma_migrations` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of Ma_migrations
-- ----------------------------
BEGIN;
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20230620180908, 'Install', '2025-05-14 17:59:55', '2025-05-14 17:59:56', 0);
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20230620180916, 'InstallData', '2025-05-14 17:59:56', '2025-05-14 17:59:58', 0);
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20230622221507, 'Version200', '2025-05-14 17:59:58', '2025-05-14 17:59:59', 0);
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20230719211338, 'Version201', '2025-05-14 17:59:59', '2025-05-14 17:59:59', 0);
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20230905060702, 'Version202', '2025-05-14 17:59:59', '2025-05-14 17:59:59', 0);
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20231112093414, 'Version205', '2025-05-14 17:59:59', '2025-05-14 17:59:59', 0);
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20231229043002, 'Version206', '2025-05-14 17:59:59', '2025-05-14 18:00:00', 0);
INSERT INTO `Ma_migrations` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES (20250412134127, 'Version222', '2025-05-14 18:00:00', '2025-05-14 18:00:00', 0);
COMMIT;

-- ----------------------------
-- Table structure for Ma_notice_log
-- ----------------------------
DROP TABLE IF EXISTS `Ma_notice_log`;
CREATE TABLE `Ma_notice_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `introduce` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '介绍',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '内容',
  `weigh` int(11) DEFAULT NULL COMMENT '排序',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='平台消息';

-- ----------------------------
-- Records of Ma_notice_log
-- ----------------------------
BEGIN;
INSERT INTO `Ma_notice_log` (`id`, `title`, `introduce`, `content`, `weigh`, `status`, `create_time`, `update_time`) VALUES (1, '平台消息123', '平台消息123', '<p>平台消息123</p>', 1, 1, 1747240114, 1747240114);
COMMIT;

-- ----------------------------
-- Table structure for Ma_question_coupon
-- ----------------------------
DROP TABLE IF EXISTS `Ma_question_coupon`;
CREATE TABLE `Ma_question_coupon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(130) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '问券标题',
  `introduce` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '介绍',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '详细内容',
  `start_time` int(11) DEFAULT NULL COMMENT '开始时间',
  `end_time` int(11) DEFAULT NULL COMMENT '结束时间',
  `answer` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '答案',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='调查问券';

-- ----------------------------
-- Records of Ma_question_coupon
-- ----------------------------
BEGIN;
INSERT INTO `Ma_question_coupon` (`id`, `title`, `introduce`, `content`, `start_time`, `end_time`, `answer`, `status`, `create_time`, `update_time`) VALUES (1, '这是问券标题', '问券标题111介绍', '<ul><li>正文</li></ul>', 1747152000, 1747324800, '[]', 1, 1747237136, 1748426016);
INSERT INTO `Ma_question_coupon` (`id`, `title`, `introduce`, `content`, `start_time`, `end_time`, `answer`, `status`, `create_time`, `update_time`) VALUES (4, '八段锦节奏是否过快', '123123', '<div data-w-e-type=\"todo\">&lt;input type=\"checkbox\" disabled &gt;123</div>', 1748361600, 1748620800, '[]', 1, 1748424959, 1753950189);
INSERT INTO `Ma_question_coupon` (`id`, `title`, `introduce`, `content`, `start_time`, `end_time`, `answer`, `status`, `create_time`, `update_time`) VALUES (5, '有氧有健内容是否有效', '123', '<p>123</p>', 1748361600, 1748620800, '[\"12333\",\"22222\"]', 1, 1748425022, 1751021674);
INSERT INTO `Ma_question_coupon` (`id`, `title`, `introduce`, `content`, `start_time`, `end_time`, `answer`, `status`, `create_time`, `update_time`) VALUES (6, '健康讲堂需求统计', NULL, '<div data-w-e-type=\"todo\">&lt;input type=\"checkbox\" disabled &gt;科普类</div><div data-w-e-type=\"todo\">&lt;input type=\"checkbox\" disabled &gt;健康类</div><div data-w-e-type=\"todo\">&lt;input type=\"checkbox\" disabled &gt;1</div><div data-w-e-type=\"todo\">&lt;input type=\"checkbox\" disabled &gt;2</div><div data-w-e-type=\"todo\">&lt;input type=\"checkbox\" disabled &gt;3</div><div data-w-e-type=\"todo\">&lt;input type=\"checkbox\" disabled &gt;4</div>', NULL, NULL, '[\"\"]', 1, 1753950350, 1753950350);
COMMIT;

-- ----------------------------
-- Table structure for Ma_question_user
-- ----------------------------
DROP TABLE IF EXISTS `Ma_question_user`;
CREATE TABLE `Ma_question_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL COMMENT '用户ID',
  `question_coupon_id` int(11) DEFAULT NULL COMMENT '调查问券ID',
  `answer` varchar(1000) DEFAULT NULL COMMENT '答案',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='用户回答记录';

-- ----------------------------
-- Records of Ma_question_user
-- ----------------------------
BEGIN;
INSERT INTO `Ma_question_user` (`id`, `user_id`, `question_coupon_id`, `answer`, `create_time`) VALUES (1, 1, 3, '\"橙子\"', 1748417315);
INSERT INTO `Ma_question_user` (`id`, `user_id`, `question_coupon_id`, `answer`, `create_time`) VALUES (2, 1, 3, '\"香蕉\"', 1748417325);
INSERT INTO `Ma_question_user` (`id`, `user_id`, `question_coupon_id`, `answer`, `create_time`) VALUES (3, 1, 5, '\"12333\"', 1748426054);
INSERT INTO `Ma_question_user` (`id`, `user_id`, `question_coupon_id`, `answer`, `create_time`) VALUES (4, 1, 5, '\"22222\"', 1748502219);
INSERT INTO `Ma_question_user` (`id`, `user_id`, `question_coupon_id`, `answer`, `create_time`) VALUES (5, 1, 5, '\"12333\"', 1748503724);
COMMIT;

-- ----------------------------
-- Table structure for Ma_security_data_recycle
-- ----------------------------
DROP TABLE IF EXISTS `Ma_security_data_recycle`;
CREATE TABLE `Ma_security_data_recycle` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则名称',
  `controller` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '控制器',
  `controller_as` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '控制器别名',
  `data_table` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '对应数据表',
  `connection` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据库连接配置标识',
  `primary_key` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据表主键',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='回收规则表';

-- ----------------------------
-- Records of Ma_security_data_recycle
-- ----------------------------
BEGIN;
INSERT INTO `Ma_security_data_recycle` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `status`, `update_time`, `create_time`) VALUES (1, '管理员', 'auth/Admin.php', 'auth/admin', 'admin', '', 'id', 1, 1747216796, 1747216796);
INSERT INTO `Ma_security_data_recycle` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `status`, `update_time`, `create_time`) VALUES (2, '管理员日志', 'auth/AdminLog.php', 'auth/adminlog', 'admin_log', '', 'id', 1, 1747216796, 1747216796);
INSERT INTO `Ma_security_data_recycle` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `status`, `update_time`, `create_time`) VALUES (3, '菜单规则', 'auth/Menu.php', 'auth/menu', 'menu_rule', '', 'id', 1, 1747216796, 1747216796);
INSERT INTO `Ma_security_data_recycle` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `status`, `update_time`, `create_time`) VALUES (4, '系统配置项', 'routine/Config.php', 'routine/config', 'config', '', 'id', 1, 1747216796, 1747216796);
INSERT INTO `Ma_security_data_recycle` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `status`, `update_time`, `create_time`) VALUES (5, '会员', 'user/User.php', 'user/user', 'user', '', 'id', 1, 1747216796, 1747216796);
INSERT INTO `Ma_security_data_recycle` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `status`, `update_time`, `create_time`) VALUES (6, '数据回收规则', 'security/DataRecycle.php', 'security/datarecycle', 'security_data_recycle', '', 'id', 1, 1747216796, 1747216796);
COMMIT;

-- ----------------------------
-- Table structure for Ma_security_data_recycle_log
-- ----------------------------
DROP TABLE IF EXISTS `Ma_security_data_recycle_log`;
CREATE TABLE `Ma_security_data_recycle_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作管理员',
  `recycle_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '回收规则ID',
  `data` text COLLATE utf8mb4_unicode_ci COMMENT '回收的数据',
  `data_table` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据表',
  `connection` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据库连接配置标识',
  `primary_key` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据表主键',
  `is_restore` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否已还原:0=否,1=是',
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作者IP',
  `useragent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='数据回收记录表';

-- ----------------------------
-- Records of Ma_security_data_recycle_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_security_sensitive_data
-- ----------------------------
DROP TABLE IF EXISTS `Ma_security_sensitive_data`;
CREATE TABLE `Ma_security_sensitive_data` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则名称',
  `controller` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '控制器',
  `controller_as` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '控制器别名',
  `data_table` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '对应数据表',
  `connection` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据库连接配置标识',
  `primary_key` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据表主键',
  `data_fields` text COLLATE utf8mb4_unicode_ci COMMENT '敏感数据字段',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='敏感数据规则表';

-- ----------------------------
-- Records of Ma_security_sensitive_data
-- ----------------------------
BEGIN;
INSERT INTO `Ma_security_sensitive_data` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `data_fields`, `status`, `update_time`, `create_time`) VALUES (1, '管理员数据', 'auth/Admin.php', 'auth/admin', 'admin', '', 'id', '{\"username\":\"用户名\",\"mobile\":\"手机\",\"password\":\"密码\",\"status\":\"状态\"}', 1, 1747216796, 1747216796);
INSERT INTO `Ma_security_sensitive_data` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `data_fields`, `status`, `update_time`, `create_time`) VALUES (2, '会员数据', 'user/User.php', 'user/user', 'user', '', 'id', '{\"username\":\"用户名\",\"mobile\":\"手机号\",\"password\":\"密码\",\"status\":\"状态\",\"email\":\"邮箱地址\"}', 1, 1747216796, 1747216796);
INSERT INTO `Ma_security_sensitive_data` (`id`, `name`, `controller`, `controller_as`, `data_table`, `connection`, `primary_key`, `data_fields`, `status`, `update_time`, `create_time`) VALUES (3, '管理员权限', 'auth/Group.php', 'auth/group', 'admin_group', '', 'id', '{\"rules\":\"权限规则ID\"}', 1, 1747216796, 1747216796);
COMMIT;

-- ----------------------------
-- Table structure for Ma_security_sensitive_data_log
-- ----------------------------
DROP TABLE IF EXISTS `Ma_security_sensitive_data_log`;
CREATE TABLE `Ma_security_sensitive_data_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作管理员',
  `sensitive_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '敏感数据规则ID',
  `data_table` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据表',
  `connection` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据库连接配置标识',
  `primary_key` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据表主键',
  `data_field` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '被修改字段',
  `data_comment` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '被修改项',
  `id_value` int(11) NOT NULL DEFAULT '0' COMMENT '被修改项主键值',
  `before` text COLLATE utf8mb4_unicode_ci COMMENT '修改前',
  `after` text COLLATE utf8mb4_unicode_ci COMMENT '修改后',
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作者IP',
  `useragent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `is_rollback` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否已回滚:0=否,1=是',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='敏感数据修改记录';

-- ----------------------------
-- Records of Ma_security_sensitive_data_log
-- ----------------------------
BEGIN;
INSERT INTO `Ma_security_sensitive_data_log` (`id`, `admin_id`, `sensitive_id`, `data_table`, `connection`, `primary_key`, `data_field`, `data_comment`, `id_value`, `before`, `after`, `ip`, `useragent`, `is_rollback`, `create_time`) VALUES (1, 1, 2, 'user', '', 'id', 'password', '密码', 1, '$2y$10$U9In429OMivO7KoV75Pc..oAXA6xn/2pMLv/JtdkmDO8ad9Sp4ic.', '******', '223.73.115.79', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, 1747323408);
COMMIT;

-- ----------------------------
-- Table structure for Ma_test_build
-- ----------------------------
DROP TABLE IF EXISTS `Ma_test_build`;
CREATE TABLE `Ma_test_build` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
  `keyword_rows` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '关键词',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '内容',
  `views` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
  `likes` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '有帮助数',
  `dislikes` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '无帮助数',
  `note_textarea` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `weigh` int(11) NOT NULL DEFAULT '0' COMMENT '权重',
  `update_time` bigint(20) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(20) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='知识库表';

-- ----------------------------
-- Records of Ma_test_build
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_token
-- ----------------------------
DROP TABLE IF EXISTS `Ma_token`;
CREATE TABLE `Ma_token` (
  `token` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Token',
  `type` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '类型',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  `expire_time` bigint(16) unsigned DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户Token表';

-- ----------------------------
-- Records of Ma_token
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_user
-- ----------------------------
DROP TABLE IF EXISTS `Ma_user`;
CREATE TABLE `Ma_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分组ID',
  `username` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '邮箱',
  `mobile` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '手机',
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '头像',
  `gender` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '性别:0=未知,1=男,2=女',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `money` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '余额',
  `score` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
  `last_login_time` bigint(16) unsigned DEFAULT NULL COMMENT '上次登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '上次登录IP',
  `login_failure` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '登录失败次数',
  `join_ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '加入IP',
  `join_time` bigint(16) unsigned DEFAULT NULL COMMENT '加入时间',
  `motto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '签名',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码盐（废弃待删）',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '状态:enable=启用,disable=禁用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='会员表';

-- ----------------------------
-- Records of Ma_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_user_auth
-- ----------------------------
DROP TABLE IF EXISTS `Ma_user_auth`;
CREATE TABLE `Ma_user_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `openid` varchar(255) NOT NULL COMMENT '微信openid',
  `unionid` varchar(255) DEFAULT '' COMMENT '微信unionid',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户授权表';

-- ----------------------------
-- Records of Ma_user_auth
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_user_course
-- ----------------------------
DROP TABLE IF EXISTS `Ma_user_course`;
CREATE TABLE `Ma_user_course` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `course_cate_id` int(11) DEFAULT NULL COMMENT '分类ID',
  `create_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of Ma_user_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_user_group
-- ----------------------------
DROP TABLE IF EXISTS `Ma_user_group`;
CREATE TABLE `Ma_user_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组名',
  `rules` text COLLATE utf8mb4_unicode_ci COMMENT '权限节点',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='会员组表';

-- ----------------------------
-- Records of Ma_user_group
-- ----------------------------
BEGIN;
INSERT INTO `Ma_user_group` (`id`, `name`, `rules`, `status`, `update_time`, `create_time`) VALUES (1, '默认分组', '*', 1, 1747216796, 1747216796);
COMMIT;

-- ----------------------------
-- Table structure for Ma_user_money_log
-- ----------------------------
DROP TABLE IF EXISTS `Ma_user_money_log`;
CREATE TABLE `Ma_user_money_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `money` int(11) NOT NULL DEFAULT '0' COMMENT '变更余额',
  `before` int(11) NOT NULL DEFAULT '0' COMMENT '变更前余额',
  `after` int(11) NOT NULL DEFAULT '0' COMMENT '变更后余额',
  `memo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='会员余额变动表';

-- ----------------------------
-- Records of Ma_user_money_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for Ma_user_rule
-- ----------------------------
DROP TABLE IF EXISTS `Ma_user_rule`;
CREATE TABLE `Ma_user_rule` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单',
  `type` enum('route','menu_dir','menu','nav_user_menu','nav','button') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'menu' COMMENT '类型:route=路由,menu_dir=菜单目录,menu=菜单项,nav_user_menu=顶栏会员菜单下拉项,nav=顶栏菜单项,button=页面按钮',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则名称',
  `path` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '路由路径',
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图标',
  `menu_type` enum('tab','link','iframe') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tab' COMMENT '菜单类型:tab=选项卡,link=链接,iframe=Iframe',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Url',
  `component` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组件路径',
  `no_login_valid` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '未登录有效:0=否,1=是',
  `extend` enum('none','add_rules_only','add_menu_only') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none' COMMENT '扩展属性:none=无,add_rules_only=只添加为路由,add_menu_only=只添加为菜单',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `weigh` int(11) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
  `update_time` bigint(16) unsigned DEFAULT NULL COMMENT '更新时间',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='会员菜单权限规则表';

-- ----------------------------
-- Records of Ma_user_rule
-- ----------------------------
BEGIN;
INSERT INTO `Ma_user_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `no_login_valid`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (1, 0, 'menu_dir', '我的账户', 'account', 'account', 'fa fa-user-circle', 'tab', '', '', 0, 'none', '', 98, 1, 1747216796, 1747216796);
INSERT INTO `Ma_user_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `no_login_valid`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (2, 1, 'menu', '账户概览', 'account/overview', 'account/overview', 'fa fa-home', 'tab', '', '/src/views/frontend/user/account/overview.vue', 0, 'none', '', 99, 1, 1747216796, 1747216796);
INSERT INTO `Ma_user_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `no_login_valid`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (3, 1, 'menu', '个人资料', 'account/profile', 'account/profile', 'fa fa-user-circle-o', 'tab', '', '/src/views/frontend/user/account/profile.vue', 0, 'none', '', 98, 1, 1747216796, 1747216796);
INSERT INTO `Ma_user_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `no_login_valid`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (4, 1, 'menu', '修改密码', 'account/changePassword', 'account/changePassword', 'fa fa-shield', 'tab', '', '/src/views/frontend/user/account/changePassword.vue', 0, 'none', '', 97, 1, 1747216796, 1747216796);
INSERT INTO `Ma_user_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `no_login_valid`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (5, 1, 'menu', '积分记录', 'account/integral', 'account/integral', 'fa fa-tag', 'tab', '', '/src/views/frontend/user/account/integral.vue', 0, 'none', '', 96, 1, 1747216796, 1747216796);
INSERT INTO `Ma_user_rule` (`id`, `pid`, `type`, `title`, `name`, `path`, `icon`, `menu_type`, `url`, `component`, `no_login_valid`, `extend`, `remark`, `weigh`, `status`, `update_time`, `create_time`) VALUES (6, 1, 'menu', '余额记录', 'account/balance', 'account/balance', 'fa fa-money', 'tab', '', '/src/views/frontend/user/account/balance.vue', 0, 'none', '', 95, 1, 1747216796, 1747216796);
COMMIT;

-- ----------------------------
-- Table structure for Ma_user_score_log
-- ----------------------------
DROP TABLE IF EXISTS `Ma_user_score_log`;
CREATE TABLE `Ma_user_score_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '变更积分',
  `before` int(11) NOT NULL DEFAULT '0' COMMENT '变更前积分',
  `after` int(11) NOT NULL DEFAULT '0' COMMENT '变更后积分',
  `memo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` bigint(16) unsigned DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='会员积分变动表';

-- ----------------------------
-- Records of Ma_user_score_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
